﻿CREATE TRIGGER UsersProjects_Tracking_Update
ON [dbo].[UsersProjects] 
AFTER Update
AS 
BEGIN
	UPDATE Sync.UsersProjects_Tracking 
	SET LastUpdatedDate  = getdate()
    FROM Sync.UsersProjects_Tracking s JOIN INSERTED i
    ON s.ProjectID = i.ProjectID AND s.UserID = i.UserID
END














